/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mycompany.oj.Mapper;

import java.util.List;
import java.util.Map;

/**
 *
 * @author asus
 */
public interface TeacherMapper {
    
    
    //获取教师照片
    public List<Map<String,Object>> getTeacherPicureMapper(String username);
    //获取教师名字
    public List<Map<String,Object>> getTeacherNameMapper(String username);
    //获取每日提交
    public List<Map<String,Object>> getEverydayPostNumberMapper();
    //获取学生提交信息
    public List<Map<String,Object>> getStudentPostCourseNumber(String username);
    //获取学生通过信息
    public List<Map<String,Object>> getStudentPassCourseNumber(String username);
    //获取学生信息
    public List<Map<String,Object>> getStudentInformation();
    //获取注册用户数量
    public List<Map<String,Object>> getStudentCount();
    //获取竞赛题库数目
    public List<Map<String,Object>> getQuestionNumber();
    //获取实验题目数量
    public List<Map<String,Object>> getCourseNumber();
    //获取章节课程实验数目
    public List<Map<String,Object>> getAllInformation();
    //获取章节课程实验题数
    public List<Map<String,Object>> getAllInformationT();
    //修改题目信息
    public int changeQuestion(String question_name, String question_txt, String question_id);
    //修改题库信息
    public int changeCourseQuestion(String question_name, String question_txt, String question_id);
    //获取用户通过实验数
    public List<Map<String,Object>> passNumber(String course_name);
    //获取用户提交数
    public List<Map<String,Object>> postNumber(String course_name);
    //获取实验总数
    public List<Map<String,Object>> sectionNumber(String course_name);
    //获取实验总题数
    public List<Map<String,Object>> sectionQuestionNumber(String course_name);
    //学生总人数
    public List<Map<String,Object>> studentNumber();
    //每个人完成了实验的题数
    public List<Map<String,Object>> everyStudentJindu(String course_name);
    //每道题完成的人数
    public List<Map<String,Object>> questionFinishedNumber(String course_name, String id, String Section_id);
    //获取实验截至时间
    public List<Map<String,Object>> getEndData(String coursename, String sectionnum);
    //获取所有课程的实验号
    public List<Map<String,Object>> getCourseId(String coursename);
    //获取章节的题号
    public List<Map<String,Object>> getSectionNum(String coursename, String Section_id);
    //获取章节的题目
    public List<Map<String,Object>> getQuestionCourseId(String coursename, String Section_id);
    //删除题目
    public int deleteAnswer(String question_id);
    //学生每个人完成的题目数
    public List<Map<String,Object>> everyStudentFinishedCourseNumber(String coursename, String Account_id);
    //上传蓝桥题目
    public String[] importquestion(String kind_id, String standard_answer, String question_text, String Difficult_id, String question_name, String language);
    //上传实验题目
    public String[] importcoursequestion(String question_name, String Section_id, String question_text, String question_answer);
    //获取Section.id
    public List<Map<String,Object>> getSectionid(String coursename, String setion_num);
}
